SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001406s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194897 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194897 [ RunTime:0.003690s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974268,733674,220590,522466,180987,278604,151123,415087,106143,376418,318580,969789,2322,387528,917494,30141,333532,399008,1018826,405463,216739,547635,600359,13460,106213,747744,309007,556000,18162,641306,758594,38587,221309,922768,699505,849104,865814,440857,970663,529075,839574,67315,986883,1025683,598461,273095,226800,754864,939064,967383,199774,741943,364414,157170,927011,892433,109491,491493,645002,355487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]