SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001265s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538643 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538643 [ RunTime:0.001563s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984713,588882,511163,475290,590169,299933,501340,884008,925161,25887,555135,199246,684701,944896,709514,596250,61130,891557,584205,575751,368932,632992,429898,554654,74834,411164,1041363,236588,815379,345305,452193,154724,800557,688445,746586,37529,686144,635804,540960,877256,931160,690739,41934,304735,208747,110504,22588,175624,915169,815797,566105,725477,261484,883822,131951,243238,267672,863778,119337,366330) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]