SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 938051 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 938051 [ RunTime:0.002390s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (630438,826154,389027,500597,500676,949352,865098,142749,617084,722229,367903,180985,892879,5072,812971,1017822,1024635,1041211,300946,89709,805204,860836,675819,1020738,455153,266865,919000,265850,659136,721357,742751,753780,267944,93165,349876,428877,449669,201805,489874,661378,727187,526193,624191,348564,89701,882386,699785,741401,148001,16851,118281,719917,105001,462221,544600,62827,877441,885578,952798,523824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 938051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 938051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]