SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004344s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029602 LIMIT 1 [ RunTime:0.007923s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029602 [ RunTime:0.009492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728657,127640,52450,604821,923844,622112,337072,843799,145585,499294,882760,398704,227643,2841,441209,975023,705628,476652,156394,157439,723937,98749,732908,309586,717505,632373,300219,327960,280538,561669,987196,756867,1014751,53653,890229,704673,488896,619212,915556,690052,308234,1047761,594872,310895,541208,831488,454829,104019,177665,719679,837424,474614,186267,26481,553616,296431,858443,442479,766478,852901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029602 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029602 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.009681s ]