SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002076s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544053 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544053 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480659,156810,276303,1044748,627624,483605,149738,244025,268237,195233,37557,550254,482279,606821,383992,49218,1046930,401702,878833,230395,365040,487816,427741,576301,210935,828088,405154,216509,752171,577419,555040,311753,559943,427402,545242,190699,11937,905325,501234,1014499,553831,776691,406758,366603,488831,638260,481082,394916,74727,966034,408762,413751,807122,424365,531846,303722,1042209,506935,290921,882779) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]