SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 384421 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 384421 [ RunTime:0.002080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136029,968044,189074,320063,912058,398483,476942,913079,937825,188759,260147,2166,433420,483495,165429,569203,452186,449160,242613,479279,967357,217346,38076,371041,380824,687771,778241,667597,890204,450195,1023126,1034144,220552,56245,846230,550724,792221,848258,948824,515864,530321,314463,997960,568963,308140,11806,802230,938334,227374,76178,911256,973124,61403,465111,420690,289220,647716,231157,160601,257515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 384421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 384421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]