SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102928 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102928 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581921,540282,510059,889930,579394,280668,1045811,680368,507300,408821,328047,211395,946268,1018119,691522,960066,214456,222184,975010,96379,84321,200297,608482,164796,345452,426160,89174,652692,478428,468063,453039,941084,42469,663605,99703,720687,923729,831437,479458,732345,409149,504799,922560,592822,226567,103934,617629,105740,262096,628588,62519,1022385,1005123,305391,95726,785424,939255,450946,466525,237585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004338s ]