SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001494s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004020 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004020 [ RunTime:0.005924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044178,1042844,993532,764920,525850,911893,723518,948894,751821,680256,393113,627719,375470,128461,914813,295373,18278,457068,416277,546734,360503,608569,353167,587954,935165,110364,207916,945921,1021818,861217,289501,614977,384171,228426,943143,643682,508645,547423,127330,79352,223472,946251,300904,1013301,51441,714471,71595,973141,371117,538489,834421,43312,815333,950048,254125,523555,952643,391813,566154,215748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004020 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004020 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001296s ]