SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 564968 LIMIT 1 [ RunTime:0.000722s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 564968 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111928,918399,505623,265926,482827,655292,740190,28284,589944,153414,949802,308003,34379,297018,590463,288646,935864,725059,89492,409216,722907,314772,221951,311785,991237,233819,715743,675522,414324,91730,534306,426768,104087,476324,758578,540042,218071,821492,845705,931962,1003230,519538,737081,773974,466457,1027309,62935,416650,526211,1015091,1048270,430595,23765,99934,840777,392428,287316,134901,227016,297224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 564968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 564968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]