SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001513s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 318383 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 318383 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582917,663930,748870,981138,254734,55108,272883,290169,410596,371847,327448,518238,744220,620970,1024836,703799,882507,1041339,818167,348315,231160,122618,549954,442949,193097,702508,201840,291370,243625,159146,21314,380271,62465,702351,446673,991516,675423,708570,629094,15644,27320,150108,314846,896237,159059,884407,390707,828599,148911,207280,852738,502693,504254,132461,425690,368867,498762,477784,934254,985969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 318383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 318383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000909s ]