SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542181 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542181 [ RunTime:0.002026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197741,436574,376050,20395,471371,211916,109381,839993,366032,670961,668870,386677,289276,1043992,549538,1025755,691404,652924,558904,867849,82772,941029,1012922,906706,650855,393824,776825,540840,7570,329355,591630,668234,540426,774341,799912,648272,766079,184567,73095,20809,619422,2607,501620,894444,353928,8452,604378,462415,67142,378798,234188,332074,613454,788814,370319,612830,661130,922778,817662,833797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542181 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542181 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]