SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501116 LIMIT 1 [ RunTime:0.002525s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501116 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990129,376664,571704,1804,912697,319365,945232,1039028,894626,599412,716743,260821,456961,508056,596895,399325,974267,558485,89727,501176,187372,773426,599072,198023,371272,920128,666248,731266,254291,530465,275218,749281,468655,813512,972498,979863,868958,298636,788160,432396,595497,621528,219159,365977,576607,386,61916,834874,45916,197827,727954,406982,540505,298933,723265,294583,819512,558835,330986,369401) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000572s ]