SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587094 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587094 [ RunTime:0.004388s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (434096,30983,874252,282010,611323,40876,254746,183510,894570,588518,159413,628959,413514,395715,928554,74835,86259,123776,669369,977742,746746,373246,1039513,1016643,1040097,8103,300076,542662,633306,52006,386858,1013705,399044,569408,288971,106106,36639,993484,880814,764937,1019273,406285,62802,210681,699769,553200,665835,564701,1019745,906258,484037,937727,409694,306786,750307,997831,583199,561480,947694,173181) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587094 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000739s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587094 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]