SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368401 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368401 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403809,719639,990802,394409,218850,796051,81183,21907,89772,689054,776956,151510,233058,54750,288838,874698,436684,96441,201567,696171,41932,312509,955632,673256,112903,503454,205671,852251,975218,946304,778601,534929,572246,7960,1012015,1000539,640558,591358,72180,203168,763841,428833,795063,312773,365715,168721,731100,1005509,982432,86575,879917,741543,112533,906581,134635,705853,4932,814264,717162,327986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000964s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]