SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036281 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036281 [ RunTime:0.003678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102470,474067,686915,1040639,228370,633734,16542,933888,987601,365265,550582,383264,966301,64383,902942,909153,847621,817564,122854,315350,160228,559938,655314,250812,913946,868904,403642,785713,544968,466711,377944,377807,516941,413869,203135,506709,703400,828325,543814,300827,994135,688673,622725,491946,392866,270946,156190,446111,939039,155032,780025,91042,500408,187453,422409,339457,537483,363037,374856,800111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]