SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020365 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020365 [ RunTime:0.001485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677159,718976,320889,627114,277544,273594,822166,537974,931600,161107,392167,63584,528315,837224,606359,348861,371531,363416,926542,179074,707984,621898,606888,437675,103028,21836,441932,1011199,499040,893348,860340,484978,324081,816289,1043458,608182,465818,42307,778715,198103,211390,1010959,173664,891279,83352,537023,701939,268921,349663,204389,832006,331487,23780,43941,573583,669257,795569,474864,65255,681023) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020365 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000645s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020365 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000736s ]