SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506250 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506250 [ RunTime:0.002140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (676578,622287,955148,734464,197857,1030895,405073,686309,640087,439460,241538,687406,746552,790043,941178,543150,566172,559534,600396,849806,843495,575099,778344,61239,96243,171114,453036,157157,378254,297632,189803,1041454,268747,329301,963034,909040,527124,199963,147498,718254,755316,475214,688814,357208,641557,858191,533843,952657,312614,943721,525888,362775,304101,561631,729078,483279,238342,151065,995665,110093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]