SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801118 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801118 [ RunTime:0.003154s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177466,460571,263224,624797,167288,256629,173187,865194,371943,352675,892604,594534,245885,41363,236094,1001865,701459,821114,522567,892768,168742,182254,1009579,510648,530074,563739,799420,183170,485938,908233,421319,140989,767238,556120,972357,1015924,937911,618932,407856,469223,560498,813526,166993,773656,334448,386736,157582,639753,866866,805862,122452,930540,4397,944147,604323,967322,72304,366027,437893,992752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]