SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459313 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459313 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927893,701997,1036178,216413,1046778,374031,972744,952679,1006703,358309,393160,152334,440473,972602,500015,50093,422380,622102,775658,216658,339516,631830,1013651,170027,647578,219470,247307,511562,742461,147343,166684,8355,414251,304985,425613,734309,1011748,8906,702510,617017,557202,972095,396615,555653,270658,130088,605794,49551,1010915,156521,339133,712609,499937,136827,503781,500244,631105,521772,821644,889094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]