SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 315328 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 315328 [ RunTime:0.001931s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721070,486181,67431,115789,332550,471341,687318,48060,346717,690528,164811,627920,200448,173781,795520,64331,399335,133499,518876,181560,835455,671235,408013,117507,610231,1033438,13161,475962,695785,4491,856075,384572,354164,506640,90988,962587,890008,299876,822731,1039838,667766,559602,535532,644303,895274,566602,1027611,769080,242467,441814,604251,12901,242481,710641,517401,870864,740454,613844,88560,543694) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 315328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 315328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]