SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 989280 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 989280 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264491,829349,800358,883516,235514,1008015,345375,621612,141915,622358,776968,192456,974581,12242,593505,277154,145701,265413,969915,404395,893869,635123,258290,719870,417084,657636,352390,321399,806663,113239,236284,528121,937625,780139,906080,719804,532166,622810,268950,31783,156580,792774,999293,799172,306592,464321,792798,661873,406915,216287,432908,395073,857419,550488,196047,872243,931216,509299,1017607,987420) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 989280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 989280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001231s ]