SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001682s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026739 LIMIT 1 [ RunTime:0.001052s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026739 [ RunTime:0.005775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (543427,650200,61714,151404,190315,658978,458719,450776,521664,320086,524069,134613,481078,300329,536137,531976,788547,820691,313288,600276,712695,148638,56139,67278,908008,32096,160420,90197,269925,178269,194006,545602,626185,965887,542927,629717,448982,670792,133680,988439,42768,842847,305319,621836,1003108,510621,707252,933424,169263,916163,340300,789651,649528,798130,224381,568829,70454,121791,413922,671021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.039148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026739 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026739 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001941s ]