SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041247 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041247 [ RunTime:0.001848s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (739576,248961,213827,995992,881925,32793,857570,742151,135740,122449,238416,232360,855257,540291,637734,935153,184952,473837,309918,867799,4806,901058,68980,650639,196474,173421,1032664,714612,860609,195880,407522,95617,126852,373796,956575,462617,595294,206743,377147,359916,645544,1033064,515530,81652,978541,180679,565171,811297,893433,493701,899875,382810,321083,607898,868243,962579,82920,108621,82069,1009352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]