SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802041 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802041 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197560,49610,642176,118182,547879,528402,1002163,368740,879003,747982,165196,971852,969829,170777,110000,687784,924772,861775,699746,230062,686959,723795,759026,664297,588417,568250,967513,890650,26473,342581,760989,1018353,376882,857586,443497,333108,522750,6354,813915,430426,375617,764261,445527,890086,490027,55109,959896,197587,579998,967272,468058,556437,636066,234724,945913,423817,161796,351186,728635,85115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]