SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 830800 LIMIT 1 [ RunTime:0.000336s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 830800 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (387580,35425,1004701,1042601,985611,514925,206780,524534,949615,198198,52532,278886,652165,577596,550698,24169,373007,1039234,67980,304398,260878,242998,42332,777697,786610,600542,903893,873096,555187,70020,864572,825258,16787,10439,1041386,590830,547188,537072,341277,139628,416404,763245,437570,27309,687386,947204,180118,150123,737890,899246,237519,917697,426287,899028,308175,961976,809855,570789,1008511,878331) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 830800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 830800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]