SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506639 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506639 [ RunTime:0.001732s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593032,499328,739018,376153,316617,872080,431741,931958,383065,9735,825010,79695,154502,394060,851616,807421,805009,184621,517733,562010,214265,747085,749652,574444,1016804,494140,149350,414027,823960,621119,678306,1035870,122717,329096,437352,97939,595704,929694,917914,1026298,480585,244480,161728,34462,520996,265423,62916,791899,279424,691625,533074,487219,836520,900050,969651,257211,582592,80289,404454,403469) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]