SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001968s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512671 LIMIT 1 [ RunTime:0.001076s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512671 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (394011,742453,533755,164441,154395,877362,69757,23148,103918,397981,358883,27302,947295,428367,473634,679672,1036085,112887,678436,504127,539958,756633,920083,851327,266060,108265,864612,620044,374876,80080,440461,705938,473691,1032940,912920,874374,428591,672743,419471,613733,18979,1041964,284865,517499,116455,51420,853019,1035976,299332,305856,493812,712652,96361,946354,76521,1023742,980526,1017595,398220,889333) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]