SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401583 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401583 [ RunTime:0.002328s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (58649,46001,637032,183775,218568,389937,928436,604223,162849,306388,747356,342493,251022,618603,428691,747784,463899,37564,635043,760486,971254,91461,857112,798881,40488,481654,291281,407040,565001,932420,714503,749358,406635,65408,369031,383894,627834,761340,651954,513193,119522,865044,732576,547881,477090,81604,658810,887363,1045557,291145,417774,98093,627062,590720,641351,291018,320533,451171,263584,929065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]