SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044101 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044101 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (338188,609710,73793,243346,958295,661888,238929,430577,577446,753307,357124,1036183,852484,507270,654306,172960,36995,451383,550944,90105,643695,763453,1035908,11524,757850,193656,76345,744471,132015,193749,363290,374339,911217,50946,212220,297862,1012768,777212,950844,1028119,515244,568142,329332,969742,426085,709354,665834,356266,666620,679541,179244,365767,904963,937575,519547,1024473,22040,638305,182244,607844) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]