SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001446s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495101 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495101 [ RunTime:0.002373s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517058,754296,321869,372341,1048267,187839,62745,886488,279338,54253,530344,867250,1044272,431422,537081,536054,985816,728361,580518,579074,835773,548125,545639,656660,98740,725066,1012581,375661,159516,639198,653720,502871,841124,253800,205742,402637,532988,577901,943813,22255,230419,789751,513847,60027,864747,438483,804492,939573,815261,496941,468975,574277,609869,757944,110419,24134,652333,332314,509502,424919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]