SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327890 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327890 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665601,220149,371560,955500,395390,371809,1028882,452985,492147,1015723,212154,341288,326456,908062,1028099,257163,772366,562385,400343,474141,1010656,283403,1019907,656627,199305,311974,679364,570085,615561,1015303,318948,255532,972174,55145,112317,77474,515165,550650,709075,67771,41974,664363,719806,92508,442036,230835,804919,463927,729980,955786,452871,340739,547691,864547,365861,851307,781148,547613,614334,771214) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]