SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331760 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331760 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576295,89854,983030,692510,921448,303170,752526,356877,809361,509541,508929,653683,495440,1016476,452019,42331,223548,82908,551733,36646,351460,745548,200861,868576,1030788,19914,691585,12172,741100,758664,500064,213264,52582,388344,707151,114687,914360,926841,246590,977823,1016399,113056,132589,814960,664323,842849,318317,820472,678312,513138,88538,456081,468279,437486,1047680,247858,338516,1000482,720838,737641) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]