SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425629 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425629 [ RunTime:0.003399s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (930520,538520,496163,731827,736593,250496,490229,784887,805593,338060,245943,201403,238466,384054,958101,1024349,844719,225180,289218,832621,28010,12807,977037,356962,851680,719897,270440,414968,732950,225777,939112,338307,496438,823701,158863,233700,17901,493733,461466,19751,976471,227311,668425,386824,482086,968106,531597,375885,277009,110270,1002476,956072,685620,120314,307605,660487,745222,975054,662286,396918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425629 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425629 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000658s ]