SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 818013 LIMIT 1 [ RunTime:0.000585s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 818013 [ RunTime:0.001613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471821,137624,878383,133069,959171,728424,659927,959842,53987,876255,846877,243375,93285,787372,76972,418934,302216,3508,459021,726491,963663,116927,834921,704628,1008058,1014641,611616,479821,1024646,885696,495234,626674,391056,756333,531578,438280,732368,599908,898986,785641,788282,574737,121985,23395,398996,559408,193323,11672,1001080,755818,242246,268766,389104,891556,290399,73139,4959,468314,798089,825867) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 818013 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 818013 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]