SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501863 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501863 [ RunTime:0.001501s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040145,264475,497005,504627,282135,815127,269670,107778,786493,30792,645051,203287,663081,47185,135389,621656,264699,657609,621164,945463,1084,160551,342509,529919,711107,710991,708311,323113,606618,505628,390830,315431,484055,382478,199982,116707,326481,397102,1043640,135178,300318,197565,808784,292965,292966,86692,196402,380271,145483,595024,514657,266730,17611,554671,923547,176598,699096,372548,764246,716008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501863 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501863 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]