SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513001 LIMIT 1 [ RunTime:0.001664s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513001 [ RunTime:0.003915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970289,352823,431733,258783,1000233,634612,573306,456058,519076,407286,76441,33049,210780,106533,183281,270629,824626,343099,528691,512493,955609,272871,264322,888022,826639,684873,185054,979535,142997,154113,926037,927975,190976,1007648,225144,418245,389350,371088,599443,810667,100205,30893,440991,568165,1013297,600362,197355,860521,819842,459396,585337,117201,792132,825554,9270,952796,858692,823761,56644,760576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001000s ]