SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529482 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529482 [ RunTime:0.001813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504710,725503,903197,218940,243848,831599,323434,739179,404068,1028490,749878,752264,596534,848796,543520,632181,227746,53658,777765,723804,28214,626028,782624,772084,244944,675004,496659,375685,630743,42766,398530,682093,84318,245927,635154,721115,42400,563096,827271,477817,1021183,761015,117795,924990,251199,113915,166757,1030441,22121,770975,718862,983480,373962,678265,651697,320275,489496,208294,653688,146289) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529482 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529482 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]