SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416834 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416834 [ RunTime:0.003703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (663409,491451,444333,2499,969347,991556,350002,1006708,296141,833208,1013880,618269,1054,197597,242096,559993,884875,489546,280909,576844,863679,430465,170527,446927,405511,923840,17672,597979,198369,326951,931325,517680,197577,757316,703907,897982,484048,621277,330099,969155,1032247,529416,897731,246448,966981,239927,987876,82467,1011191,732762,623320,534538,770052,42143,620370,826662,894712,743461,508226,1019490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001801s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]