SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526421 LIMIT 1 [ RunTime:0.002030s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526421 [ RunTime:0.002113s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (720284,268316,1027804,745720,674050,314774,469740,1032843,200299,326817,183561,1017,144824,687664,1002442,327902,141314,260936,582079,743213,928194,737156,279522,870400,945573,372157,736009,523654,337250,291164,352060,1011579,437433,728216,203910,285643,495974,799512,1028788,980548,955575,896140,199172,668696,367992,487374,67227,600097,656995,598701,394944,408948,149356,220549,199608,728045,475873,249501,1001606,868632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]