SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 586654 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 586654 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (216339,378815,358160,457120,331124,43500,661475,579669,672065,972940,658611,454083,661091,911169,330405,525590,136881,21961,872488,553332,1015632,249693,342737,1021751,217724,432227,479659,810076,763394,4859,833458,951546,406797,1031584,923431,850046,169289,140528,96158,959941,79985,642953,861273,41006,878281,88032,592611,838101,1047476,793041,680641,298818,596956,204270,168915,295302,7906,922584,198776,352432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 586654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 586654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]