SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 900109 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 900109 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251354,1023099,393064,645834,121731,426184,5286,848749,14847,157860,764530,770335,928125,905508,440490,432267,215214,369076,324323,363219,264016,454514,661233,1005919,603313,915061,1047903,839613,39327,661251,465964,207910,952952,204249,484924,958165,715603,270612,391852,244128,207564,864843,973554,390409,1028406,28434,585181,187053,996368,1007863,438557,817678,482578,1037384,973538,704088,252409,478839,690310,801151) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 900109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 900109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]