SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402039 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402039 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382650,267530,545091,955381,70460,540475,245142,932339,485902,778640,245168,361939,754117,994059,379230,92273,76312,787780,441728,812677,737263,19115,103223,978956,613347,388201,267944,184448,19693,583452,376311,467799,29441,503995,255164,28569,452833,447726,120980,266814,296801,310452,527152,110968,112068,987286,221265,424512,252858,393441,396354,888169,151036,247722,230927,224720,179516,516037,885412,124809) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402039 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402039 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]