SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543303 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543303 [ RunTime:0.003749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815003,13687,638132,662236,854824,270525,126965,816031,127917,244284,291454,1003,819034,441244,632716,229110,623419,301819,983572,631737,49096,306044,965209,533652,434122,785570,980888,63248,171749,712914,904591,800314,837317,185992,922068,449295,651380,405278,423287,909453,182734,303832,480973,617039,113881,678790,844143,262293,687090,92048,472651,123895,30089,724033,372689,653342,186564,119873,734393,815850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]