SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012870 LIMIT 1 [ RunTime:0.002688s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012870 [ RunTime:0.002663s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1020684,697694,273408,1045256,320997,934041,978389,252485,761947,66265,171847,187830,817221,14048,708464,70273,345876,1024210,440492,500999,21187,617214,741338,833713,945374,619668,655267,320473,764985,495407,605415,697913,521762,194913,335786,865538,76210,409200,827775,79228,593740,358198,259007,549472,97074,858930,942328,573772,103382,41637,725114,285594,251469,212475,468111,203551,1020665,226079,199649,60192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012870 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012870 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000758s ]