SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041872 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041872 [ RunTime:0.001825s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (797294,726938,429074,963916,107646,853885,534583,178415,847507,87784,80862,49771,94149,815637,151202,622840,48548,816813,72155,662272,488139,618158,691046,574337,515655,374090,398075,284915,759141,1006457,157467,298045,169556,27071,1039744,446452,28944,481701,12568,130274,910838,385807,160726,131860,195544,717674,996363,565145,563822,800282,13096,573861,990982,151400,22511,501265,579492,431498,778581,1001583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041872 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041872 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]