SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194492 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194492 [ RunTime:0.001840s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902045,281307,1029979,693504,792689,39661,493841,737463,34577,380064,42677,594461,269369,1046774,405685,304317,597192,661980,312427,871827,795655,1720,837868,126808,319210,214340,872724,26284,104459,398234,972356,930899,868064,997169,691349,846915,644668,227839,451338,445265,995011,461647,278134,161592,110145,805167,211753,371792,385013,1017405,712597,568662,283484,172234,927727,621377,1031568,380543,348952,425371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001169s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194492 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194492 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]