SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 355396 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 355396 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (674750,32501,793463,320750,188956,936692,1025263,613642,622335,39011,327086,519040,698899,784099,777723,266249,628398,85898,704746,53454,331711,980574,677535,835409,1025815,373364,564156,854360,102389,433210,1039921,496560,741186,457028,890514,537004,753204,171202,240656,681541,873403,247544,245773,161609,105104,339121,1042747,282209,976859,763420,534870,229374,27583,393132,112571,517362,19354,337230,1024721,174581) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001890s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 355396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 355396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]