SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419030 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419030 [ RunTime:0.003807s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883309,913591,734392,283297,208796,513494,928352,922268,909789,606773,80734,919922,427771,327132,21073,523496,339523,466101,372455,993918,753980,660865,489424,228782,858877,93348,637555,314319,457869,311654,238593,905345,913074,82278,765363,257233,619923,412144,646580,208148,1021994,297987,803780,234514,424590,465963,992665,676710,993296,747445,1014833,423819,568009,654659,290431,490387,928913,288693,748871,119315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419030 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419030 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]