SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011432 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011432 [ RunTime:0.002528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (844861,518363,587298,906037,199263,804334,820944,37938,835248,381182,513904,340913,1019791,69936,1025745,760453,988298,379026,48859,383833,101497,899034,204204,267170,156195,397661,124460,719614,543208,849537,413821,504274,597860,32033,743033,518600,144841,157784,697845,53464,726498,935858,807563,575535,968787,230701,423547,662049,251975,186540,598410,808688,389088,451098,249335,727096,876707,918600,980924,752317) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011432 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011432 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000543s ]