SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28138 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28138 [ RunTime:0.001920s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846120,175472,754696,125051,385583,477297,184149,764843,182392,326836,962907,477119,429819,399570,421160,311717,307820,799717,353958,119577,97588,263735,703517,417201,30407,928187,751930,307160,119601,471706,565903,47547,630706,441569,1000762,298126,330713,203991,693587,1001385,1008925,752459,341442,488106,753867,643828,136372,452968,747163,202183,658055,1044890,1000666,908049,774934,791174,396548,400558,906045,946022) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28138 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28138 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000489s ]