SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520648 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520648 [ RunTime:0.001675s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238267,844804,632135,79586,1016488,985854,694869,877609,121764,713341,643914,363252,780552,5873,810435,332820,238475,25703,552405,324843,770263,76291,885156,1004649,409322,749266,573890,1045392,636643,272461,727904,409434,373274,685237,464934,217566,282136,439738,445179,312805,1048558,811851,77886,351086,903986,158515,385347,524416,180197,918959,855395,395038,193339,278315,482668,521873,701996,367023,882428,552819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]