SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508319 LIMIT 1 [ RunTime:0.000736s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508319 [ RunTime:0.002245s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047058,918962,138522,644310,58944,912660,223999,122178,252962,737632,447389,185826,295502,471894,307436,76939,587499,86892,591394,625520,178735,603578,661586,201691,392837,778408,463639,901375,542868,599126,450636,424664,84769,38350,916748,696425,912645,336625,612640,478584,859924,313709,758587,441557,417489,863685,600005,950110,537968,118448,900391,156189,700098,349451,668336,6177,99133,722590,776978,94712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508319 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508319 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001154s ]