SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001532s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546941 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546941 [ RunTime:0.001818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (456616,647036,715152,1017949,227890,1016214,44831,637673,1034031,754690,78547,34305,261628,102198,270931,385016,759986,1017624,1035260,396104,349397,1046611,171492,594580,148327,459390,153986,290867,517199,1026939,319915,959917,552651,851522,935456,459229,39931,239455,412416,181765,715622,61768,473429,720543,883741,73859,647782,779395,376082,205344,156452,774916,999431,941768,917881,78795,590963,753125,10432,616217) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002001s ]