SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 984607 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 984607 [ RunTime:0.002169s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (292509,2426,243508,495060,866383,589776,34465,305493,554529,479216,189744,721499,386180,868960,788142,167220,457597,445693,537481,910471,1021581,866114,650855,213151,522832,950716,510259,837349,516414,137659,864621,891951,321724,439304,528177,816029,639754,1031900,1001989,388858,118852,228697,24164,823115,1011272,833034,481823,131643,208334,759876,141966,778062,958483,470753,460187,34156,730035,474618,437680,288248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 984607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 984607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]