SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560524 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560524 [ RunTime:0.002291s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187034,13943,692307,469450,105302,1041748,278558,1031346,819516,277846,950371,836683,54772,128307,645875,97683,817800,425910,420130,371359,1007261,944371,833501,574748,235365,845340,689431,654544,585242,643254,127671,897807,839865,684703,199265,365567,564615,143420,863855,304497,515340,1010415,174392,370695,369668,836576,96724,721358,802501,211677,530828,828484,664132,518109,286621,119428,64007,688255,546033,512957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000709s ]