SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475030 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475030 [ RunTime:0.002187s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631474,195068,425971,399879,1030812,985093,774638,711782,923297,491976,504751,48633,449834,815636,448484,383572,839165,1038266,427668,331544,263686,500912,190538,153739,6931,281626,612690,182603,108642,5347,440649,830000,779764,741084,623637,63676,53059,749372,360038,699100,415786,453200,97393,620190,894672,740859,245596,799808,1014083,202809,612400,794017,584036,898545,493381,365821,922898,707700,588587,877940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]