SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547373 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547373 [ RunTime:0.003383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591518,351104,24132,974948,430708,452742,106390,673695,414536,863720,612187,374943,55959,408522,1043876,689024,7107,878391,280860,579071,776383,705227,601563,861869,615765,583896,730839,598489,501040,402470,597521,357591,262065,139428,233874,939018,470797,837820,770624,701797,859260,1021703,843072,820734,484361,390952,479657,2587,987876,865278,79902,901143,562849,51239,167914,245590,184657,533781,961808,988417) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547373 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547373 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]