SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425068 LIMIT 1 [ RunTime:0.001146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425068 [ RunTime:0.001909s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479234,246964,748723,493984,716892,350661,993840,171657,800383,713925,253803,990407,268426,696873,93804,135090,61274,264222,1025447,355932,875687,375406,970157,717319,336761,842274,947759,726942,781656,971819,265040,893082,891294,508580,603453,571454,917995,376997,1004555,696894,806376,875856,743327,56862,416143,217394,754113,161509,191471,843818,179291,550210,882180,110974,310770,837403,730598,238622,423279,444065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005609s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001203s ]