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` = 1020141 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020141 [ RunTime:0.001932s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (702199,927256,56311,450167,822689,330700,50913,767880,160940,985483,634872,61634,194794,781689,801197,643591,698764,113095,551974,253079,705486,169793,564096,959714,652517,140892,429862,543960,69012,181217,626550,1003799,647527,682819,807093,272009,32671,712188,649167,627350,260396,222625,217504,792563,463974,159456,322155,870441,899795,819287,204965,888348,608331,186714,631401,636188,543527,265635,727040,868217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]