SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412152 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412152 [ RunTime:0.005220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (723959,925967,120665,187445,538698,795562,615633,631127,41694,558747,750243,211002,337108,1028876,979784,1011587,854058,395274,472574,83909,793174,402434,1043069,463679,474266,353628,165591,452775,193928,45810,379846,905420,181798,348836,555023,189401,796767,865341,521920,53310,379566,924210,238149,600681,1002310,818763,250856,846297,427811,171617,910858,136573,822678,201632,470565,148803,631926,5381,593490,537281) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]