SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481952 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481952 [ RunTime:0.001664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165140,286668,817876,141651,348441,777090,620044,329241,896267,184610,756562,376476,943473,406064,1001603,363024,1024245,44413,790582,451356,301257,750618,177014,444800,311139,303148,530682,472670,58794,23094,562549,35176,668159,102028,577564,877522,403396,26419,713964,759437,158800,220393,494441,657969,209519,778715,8054,807456,556788,655541,581724,460300,203339,246946,121157,467313,613579,392024,374313,17320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]