SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503983 LIMIT 1 [ RunTime:0.001467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503983 [ RunTime:0.006051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906755,438097,540541,698460,48415,784215,90059,11174,813393,282860,457841,507984,777885,927767,37184,590488,558318,940768,924034,666774,790546,441175,876228,207357,17515,818206,551590,534364,571261,931262,445859,383716,409975,461708,280763,175058,842480,96986,367427,562190,251585,93208,695482,577516,329464,685199,1009424,55529,451727,91277,860936,468042,351743,962968,641014,779467,646607,81956,153706,65019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000651s ]