SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 99 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 99 [ RunTime:0.002324s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406939,107276,139610,750459,188018,654984,373206,515048,1042626,429649,431340,34132,59481,138539,107305,663742,585734,218482,779294,880684,103308,220490,380520,394808,172578,496094,967486,718075,669698,397836,822706,313393,874759,945000,148296,499583,77948,14443,830667,126316,606846,490015,753026,129123,841831,292228,938327,1005625,222443,447658,486911,829490,230016,132414,765948,434703,258247,142141,665528,463366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 99 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 99 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]