SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016714 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016714 [ RunTime:0.002137s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211778,446459,395264,371286,815819,235298,179736,657852,160878,910573,494736,669214,1003925,248640,627250,278824,988951,203138,38389,577643,512305,153143,913509,353586,534693,1020494,878264,566939,511506,921099,881946,54685,384335,924156,610565,689519,414107,472511,965866,192065,778969,842558,336870,774544,560721,137913,496753,118594,85010,209684,543586,299155,999223,475781,139258,363303,813041,855995,992918,263226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]