SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045419 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045419 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59396,306593,618113,863806,5335,333240,510951,738896,943034,741074,342225,354061,183881,138913,383166,386914,386582,794349,745326,125964,108839,106098,38212,52241,105352,598983,647427,668066,528285,454516,571084,107887,243945,500948,868839,1017213,658197,878818,25765,5602,121351,11807,312610,172334,776768,978487,890508,105143,827412,885732,7281,545825,844449,82459,843159,9274,304327,692490,356901,113270) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045419 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045419 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]